UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BIfbHB3lzIw61MuMGKHJ7eel4ftTU7EKNyCj6KSucoc='
WHERE
key_id = '46dd2e15901561a3c1e99a97f07c6327ece436b902e625ce30e4a2fec4ca362b'
AND (
token = 'BIfbHB3lzIw61MuMGKHJ7eel4ftTU7EKNyCj6KSucoc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)