UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Jit/eM8NZsTdJ45K/gV7n95CqpG3sH7a7aEcIcbnm4c='
WHERE
key_id = '24872e093412571240308b2956253e5ec330f522f9d6f0b6650415fe124fcf2a'
AND (
token = 'Jit/eM8NZsTdJ45K/gV7n95CqpG3sH7a7aEcIcbnm4c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)