UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'NC7XCadDhgWDn0wKMPeO3+2FxsS8JS9rF4fQBSKSHsA=' 
WHERE 
  key_id = '779679088c0aa91b91dcdbe5c567969cc9c7e214cef1af8732868b4d54af65eb' 
  AND (
    token = 'NC7XCadDhgWDn0wKMPeO3+2FxsS8JS9rF4fQBSKSHsA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027