UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'kVOs6uqKz9U+B/I1dPB1YxXS50D6opc9Sxp3sswdYCA=' 
WHERE 
  key_id = 'd9a95ac38c88ec038141ea30bb44a8f875823ae3a472add6394a15b35af14a23' 
  AND (
    token = 'kVOs6uqKz9U+B/I1dPB1YxXS50D6opc9Sxp3sswdYCA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022