UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'WlDs9nNqweZf7K/c59bn73Mz4a1veJ/ldnjHQVE5kX0=' 
WHERE 
  key_id = '33b2a96cced1015869beb1729c99ca9d8ccbd29f1c88d7d7e5123689d79b3f1b' 
  AND (
    token = 'WlDs9nNqweZf7K/c59bn73Mz4a1veJ/ldnjHQVE5kX0=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00046