UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'GXVW1KgrpJEWTsLukFpBuKpTks9akeO4g9L8mw159lE=' 
WHERE 
  key_id = '716f51e52a239799dd3fe81e0a2b930ae05559defd43ab3a4fa0ebfbd0f31bda' 
  AND (
    token = 'GXVW1KgrpJEWTsLukFpBuKpTks9akeO4g9L8mw159lE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00012