UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AvAtsD2/tz4jh3O9d0Ee6Xy9lW3TnBIZHTB97Ji7J5Q='
WHERE
key_id = '7754803180d0fba3fb29aab84cc93b93abbe324f86290edeef8916676b693fc1'
AND (
token = 'AvAtsD2/tz4jh3O9d0Ee6Xy9lW3TnBIZHTB97Ji7J5Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)