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