UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'bOoA+Ub/gdwgwOGJF86vib+D23h8j+Ml1r4t1B4eOXA=' 
WHERE 
  key_id = 'a6a9f77db941d50e1e0200b0639f57aaef37e7e1e6a2c30fa3d09f29cb8bd88a' 
  AND (
    token = 'bOoA+Ub/gdwgwOGJF86vib+D23h8j+Ml1r4t1B4eOXA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00033