UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HLScZwcFcAsMHcYbjGaxu0rD7G6Cfw7V3c+49YsAtI4='
WHERE
key_id = 'a8c1d7e3b5e80ffdb0db6c43c21e34aa71b8ab18c9042ed6868fd5d4c859f921'
AND (
token = 'HLScZwcFcAsMHcYbjGaxu0rD7G6Cfw7V3c+49YsAtI4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)