UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Ab8yhsURcyfqkQdYVB5qVMqIIuB5WHogl2GxyrWlkdE='
WHERE
key_id = 'f61edd7b0c03deb0589dde94f662c28f8759e873d0bc2fd5a8ad6127ee15890a'
AND (
token = 'Ab8yhsURcyfqkQdYVB5qVMqIIuB5WHogl2GxyrWlkdE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)