UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zisKhqy8UMbXPD0pUEEGDfyRiC/Yaexti0prmlyQmZE='
WHERE
key_id = '7359aac8a21ac16cb1266eb4f1879c49ede07d44c25d69ae0d0f9a4a10046c8a'
AND (
token = 'zisKhqy8UMbXPD0pUEEGDfyRiC/Yaexti0prmlyQmZE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)