UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'o6wEHDW45kBacFWUs73VpKpsX5V0Gg5TUtWjHVQ1aM8=' 
WHERE 
  key_id = 'c13a4f22c3e3e1799b167454c067b13a6b0a18ffbf01e1bffbddc36e5f951767' 
  AND (
    token = 'o6wEHDW45kBacFWUs73VpKpsX5V0Gg5TUtWjHVQ1aM8=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00038