UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'T7HV4mM6b5LUZJ97P1Mskq7JtaF2xv2K1BnLqCa0Gs4='
WHERE
key_id = 'aff3a5cece72893a72c5ff9088e5f381a38b1bbaf020bd4aca1ec2063c46b807'
AND (
token = 'T7HV4mM6b5LUZJ97P1Mskq7JtaF2xv2K1BnLqCa0Gs4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)