UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '2+Fua03n/loXg85rsfJtrlOtvz2BBd2jj4TxosNhUVU=' 
WHERE 
  key_id = '70242ba02c5fe393ee41e7430f3ec8c8aee606be95bf1b2b719510d3108d2f61' 
  AND (
    token = '2+Fua03n/loXg85rsfJtrlOtvz2BBd2jj4TxosNhUVU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00065