UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fkQccwUnKWyeNs3F3WDH6XE5SRlHsUCLnpQ9U1vQVg0='
WHERE
key_id = '42f33d662a1e26c1e104490cc54ed66d78ed16a5c026475ff160d019adc5195b'
AND (
token = 'fkQccwUnKWyeNs3F3WDH6XE5SRlHsUCLnpQ9U1vQVg0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)