UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'K9i/GWpKnKaFpC2zcRafyLhGAvm3wjeUXlUdphb45UE='
WHERE
key_id = '9ba63431bbc5c42c14f1222e6557bcb5f1a00e7798252c6c1ef81f3ac6d8c297'
AND (
token = 'K9i/GWpKnKaFpC2zcRafyLhGAvm3wjeUXlUdphb45UE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)