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