UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'PV529veWtU7B/RCk/8yAvLZKhl5d46MM1lZHqu1/syY=' 
WHERE 
  key_id = '5c2a56723dcc2a93f4cd42bf766c15293f9e08b83c2547f2378bfdf722e6f120' 
  AND (
    token = 'PV529veWtU7B/RCk/8yAvLZKhl5d46MM1lZHqu1/syY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00028