UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '177um27cdSTBMmJQ2M5ilzbSbfSmDTXsWHVKzQTpCzM='
WHERE
key_id = '9c19af02cfdc204519ff6fd1e4a3147d89ba78b6f9393a2cb1c3481d9f619edf'
AND (
token = '177um27cdSTBMmJQ2M5ilzbSbfSmDTXsWHVKzQTpCzM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)