UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N9vby64x0wXvamxWV+VqwtAxbo8iY9I3+knrSg6NYH4='
WHERE
key_id = '74320b164c998c58dc58d3b02c99cb5463505498327043e08dadd2b0abbe3748'
AND (
token = 'N9vby64x0wXvamxWV+VqwtAxbo8iY9I3+knrSg6NYH4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)