UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'pg+i+dgnDShrlsLze3+zeBmEDPAIDlN8pvwPLYj7fXQ=' 
WHERE 
  key_id = 'd85f0bcab6a77840fa0e126c115b5f2dbd141c07030b0b1eae37e574ab325a9b' 
  AND (
    token = 'pg+i+dgnDShrlsLze3+zeBmEDPAIDlN8pvwPLYj7fXQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00016