UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'h7HLrt4Tb45MmGO0pwgBdQz8Etshmpz2e/7yJfPV8xI='
WHERE
key_id = 'e057a4da0557005ff154880b10437c7c0ed06ebe0aed7daa6f010e299b35772e'
AND (
token = 'h7HLrt4Tb45MmGO0pwgBdQz8Etshmpz2e/7yJfPV8xI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)