UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5aNbNrRWoS7e7iZKSFrwlC1y38RHKRkPdVzSYA5U6/g='
WHERE
key_id = '0c52f787f37761aca10c6d89df68f66daa4a4cb042cff27b8d4f897f1db4159e'
AND (
token = '5aNbNrRWoS7e7iZKSFrwlC1y38RHKRkPdVzSYA5U6/g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)