UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'QVICkslwwsylzW8L0Q5WanbtVbLyQ2LBiKJ+zvh3nsc=' 
WHERE 
  key_id = 'a000a50cfe73e4b1a553bf81379efdd270957f6b3d00c2094f8f5dbe13e5502b' 
  AND (
    token = 'QVICkslwwsylzW8L0Q5WanbtVbLyQ2LBiKJ+zvh3nsc=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00038