UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QXmrL6h4B7QpVmYRviFPFiaPFPgmAjTZv73r11MOfqc='
WHERE
key_id = '20f79522578561dcf8fb2fccc9bf2f1be79e11f1ec0121df8be3c48a95d881b1'
AND (
token = 'QXmrL6h4B7QpVmYRviFPFiaPFPgmAjTZv73r11MOfqc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)