UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1ZsbHrTgFXqWb0qtcB1FS5TIuOmXXz39D6vlqD+3vyM='
WHERE
key_id = '19a3ae860ef417221683f1dd2268b8d7ae70345cee986acd9c8623d32a57b91f'
AND (
token = '1ZsbHrTgFXqWb0qtcB1FS5TIuOmXXz39D6vlqD+3vyM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)