UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0OcqdnedfTygCwqO648z09aNmrboqeMBAvJQoCyWQLc='
WHERE
key_id = '00b31d0b1dd147e7d9df5317ace02a8903619969d3318b87f30b16cbef7b6777'
AND (
token = '0OcqdnedfTygCwqO648z09aNmrboqeMBAvJQoCyWQLc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)