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