UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8CZvCgz5gnUmqxS1ClIr2pfIt2RBn8Pg57g0t9VcoMo='
WHERE
key_id = '3db9283fc05bfd597ebfb41304fe58a865a08c20f270f645a6a00fd4d47dae09'
AND (
token = '8CZvCgz5gnUmqxS1ClIr2pfIt2RBn8Pg57g0t9VcoMo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)