UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J4aI8aGwMO5tQoruaG5q5nVTuYGQ3WSYEQmPxwQ5yKU='
WHERE
key_id = '8e2ddea127ba1dda9c9e13663aadad3378d740920a8a81e45fd2a9a9862b156f'
AND (
token = 'J4aI8aGwMO5tQoruaG5q5nVTuYGQ3WSYEQmPxwQ5yKU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)