UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NZr9GUe1qLF3FiQsaVbebeOYQob8W16bxPJSq53u5pg='
WHERE
key_id = '4c6aff8aeb9cf5fa5117e511fd36ce1ff6bd9d72963ee7100fc43f652ba4ec99'
AND (
token = 'NZr9GUe1qLF3FiQsaVbebeOYQob8W16bxPJSq53u5pg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)