UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SQvFrcA/omU+u8DEUYNtCfhRyG3yk6IR+MGKxG8iYCw='
WHERE
key_id = '74870ec8e3bb709064db4ef04b63863ce7b4138e2081023c2813239816c4609a'
AND (
token = 'SQvFrcA/omU+u8DEUYNtCfhRyG3yk6IR+MGKxG8iYCw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)