UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lZHHU63n8s3V7upC7p1IEgMo8+E+r4/OSJRIRrMMiJ0='
WHERE
key_id = '9723cd499306f2e6b5dc91b24e879387e6712889beaf4bb875313b90052a6a3d'
AND (
token = 'lZHHU63n8s3V7upC7p1IEgMo8+E+r4/OSJRIRrMMiJ0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)