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