UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'YT0ZAY04v2qkDk05nr/SxafXM2SfeKCUUqtiDEMaaZg=' 
WHERE 
  key_id = '08ecb1fcb14de7e812a4c03a32eb2c6502f7127ea928ac7b94ab648a70ea6a51' 
  AND (
    token = 'YT0ZAY04v2qkDk05nr/SxafXM2SfeKCUUqtiDEMaaZg=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021